<?php
	session_start();
	require_once("../db_connect.php");
	if(!array_key_exists("user_id",$_SESSION)){
		header("Location: ../top.php");
	}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet"  href="../../css/css.css" type="text/css" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js"></script>
<script type="text/javascript" src="../../js/jquery.corner.js"></script>
<script type="text/javascript">
	function delete_volunteer(v_id){
		if(window.confirm('このボランティアを削除しますか？')){
			if(v_id == 9999){
				return true;
			}else{
				location.href = "../volunteer_function/volunteer_information_delete.php?volunteer_information_id="+v_id;
			}
		}
		else{
			window.alert('キャンセルされました'); // 警告ダイアログを表示
		}
	}
	$(document).ready(
		function() {
			$("#volunteer").click(function () {
				$("#target").attr({
					action: "./PHP/serch_function/index_search.php?target=volunteer"
				});
			});

			$("#thread").click(function () {
				$("#target").attr({
					action: "./PHP/serch_function/index_search.php?target=threads"
				});
			});
			$('.box').corner();
			$('.box2').corner();
			$('.box3').corner();
			$('.box4').corner();
			<?php
				echo array_key_exists("error",$_SESSION)?"login_error('".htmlspecialchars($_SESSION['error'],ENT_QUOTES,"UTF-8")."');":"";
				unset($_SESSION["error"]);
			?>
	});
	function login_error(error){
		alert(error);
	}
</script>
<title>提供中ボランティア情報</title>
</head>
    <body>
	<div id="container">
		<div id="header" class="box4">
			<div id="header_box" >
				<div id="title">
				</div>
				<div id="search_box">
					<a href="#" id="volunteer">ボランティア</a>｜<a href="#" id="thread">掲示板</a>
					<form method="post" action="../search_function/search_display_free.php?target=volunteer" id="target">
						<input type="text"  name="search_word"><br />
						<input type="submit" value="検索する" id="search_button">
					</form>
				</div>
			</div>
		</div>
		<div id="rightnavi" class="box">
		<?php if(empty($_SESSION["user_name"])&&empty($_SESSION["user_id"])){?>
			<h3>ログインフォーム</h3>
			<form method="post" action="./user_function/UserLogin.php">
				ID：　　<input type="text" name="id" size="10"><br />
				PASS：<input type="text" name="pass" size="10"><br />
				<input style="margin:10px 0 0 39px;" type="image" src="../img/login.png" alt="送信ボタン" name="submit" align="middle">
			</form>
			<a  href="./PHP/User_create.php"><img style="margin:-20px 0 0 39px;" src="../img/newuser.png" border="0"></a>
		<?php }else{?>
				<img src="../../img/kaiinlogo.png" id="kaiinlogo" />
				<p>ようこそ<?php echo $_SESSION['nick_name']?>さん！</p>
				<p><a href="user_infomation.php">会員情報表示</a></p>
				<p><a href="user_update.php">会員情報変更</a></p>
				<p><a href="user_display_application.php">申請中ボランティア</a></p>
				<p><a href="user_display_volunteer.php">提供中ボランティア</a></p>
				<p><a href="../volunteer_function/volunteer_information_insert.php">ボランティア作成</a></p>
				<p><a href="../user_function/logout.php">ログアウト</a></p>
				<br />
		<?php }?>
		<img src="../../img/keizilogo.png" id="keizilogo" />
<ul class="menu_margin">
<div id="thread_title_look">
<?php

	//スレッド項目取得
	$sql = "SELECT t.thread_id,count(thread_name) as thread_count,t.thread_name,max(r.response_date) as response_date,t.thread_id FROM thread AS t LEFT OUTER JOIN response AS r ON t.thread_id = r.thread_id group by t.thread_name order by response_date desc limit 0,5";
	$sth = $db->query($sql);
	if (DB::isError($sth)) {
	  exit($sth->getMessage());
	}

	//スレッド表示
	while ($data = $sth->fetchRow(DB_FETCHMODE_ASSOC)) {
	  echo "<li><a href='../response.php?thread_id=".$data['thread_id']."'>";
	  echo mb_strlen($data['thread_name'])>=9?mb_substr($data['thread_name'],0,9)."...":$data['thread_name'];
	  echo "</a></li>";
	}
?>
				</ul>
		<div id="more"><a href="../PHP/thread.php" >もっと見る...</a></div>
	</div>
			<div id="main"  class="box3">
	<h2 align="center">提供中ボランティア情報</h2>
	<br /><br />
	<form action="../volunteer_function/volunteer_information_delete.php" method="POST" >
	<table id="table-05" align="center">
	<tr>
	<th></th>
	<th>ボランティア名</th>
	<th width="100px;">活動開始日</th>
	<th width="45px;"></th>
	<th width="45px;"></th>
	<th width="45px;"></th>
	</tr>
<?php
	$user_id = $_SESSION['user_id'];
	$sql = "	SELECT DISTINCT  volunteer_information_id, volunteer_name, activity_date
				FROM volunteer_information
				WHERE user_id =?";

	$res =& $db->query($sql, $user_id);

	if (PEAR::isError($res)) {
		die($res->getMessage());
	}
	//自分が登録したボランティア情報を表示する
	//詳しく知りたい場合は「詳細」ボタンを押す↓
	//display_volunteer_informatino.phpで詳細を表示する。
	$count = 0;
	while ($data = $res->fetchRow(DB_FETCHMODE_ASSOC)) {
		print("
			<tr>
			<td><input type='checkbox' name='volunteer_information[]' value='".$data['volunteer_information_id']."' /></td>
			<td>".$data['volunteer_name']."</td>
			<td>".$data['activity_date']."</td>
			<td><a href='../volunteer_function/display_volunteer_information.php?volunteer_information_id=".$data['volunteer_information_id']."'>詳細</a></td>
			<td><a href='../volunteer_function/volunteer_information_update.php?volunteer_information_id=".$data['volunteer_information_id']."'>編集</a></td>
			<td><a href='#' onClick='delete_volunteer(".$data['volunteer_information_id'].")'>削除</a></td>
			</tr>
		");
		$count = $count + 1;
	}
?>
 </table>
 <?php
 	if($count!=0) echo "<input type='submit' value='削除' id='volunteer_delete_submit' onClick='delete_volunteer(9999)' style='WIDTH: 70px; HEIGHT: 30px'/>";
 ?>
 </form>
 <br />
 <br />
		</div>
<div id="space"></div>
		</div>
    </body>
</html>








